MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

5 rows where Artist Role = 72

View and edit SQL

Suggested facets: Is Public Domain, Department, Object Name, Culture, Artist Display Name, Artist Display Bio, Artist Alpha Sort, Artist Begin Date, Artist End Date, Object Date, Object Begin Date, Object End Date, Credit Line, Classification

Link rowid ▼ Object Number Is Highlight Is Public Domain Object ID Department Object Name Title Culture Period Dynasty Reign Portfolio Artist Role Artist Prefix Artist Display Name Artist Display Bio Artist Suffix Artist Alpha Sort Artist Nationality Artist Begin Date Artist End Date Object Date Object Begin Date Object End Date Medium Dimensions Credit Line Geography Type City State County Country Region Subregion Locale Locus Excavation River Classification Rights and Reproduction Link Resource Repository
15143 67.654.299 0 1 16409 American Decorative Arts 1 Drawing 23 Cartoon for window, Saint Anselm, St. John's Chapel Episcopal Divinity School, Cambridge, Massachusetts American 1         Artist|Maker|Artist 72   Louis Comfort Tiffany|Tiffany Studios|Frederick Wilson American, New York 1848–1933 New York|1902–32|American (born Ireland) Dublin 1858-1932 Los Angeles, California   Tiffany, Louis Comfort|Tiffany Studios |Wilson, Frederick 2361   1848 |1902 |1858 1933 |1932 |1932 1912 1912 1912 Watercolor, gouache, ink, and graphite on wove paper 2572 Overall: 34 3/4 x 20 1/4in. (88.3 x 51.4cm) Purchase, Walter Hoving and Julia T. Weld Gifts and Dodge Fund, 1967 Made in 1       United States 3             Drawings 9   Metropolitan Museum of Art, New York, NY 1
15144 67.654.300 0 1 16410 American Decorative Arts 1 Drawing 23 Cartoon for window, Wycliffe, St. John's Chapel Episcopal Divinity School, Cambridge, Massachusetts American 1         Artist|Maker|Artist 72   Louis Comfort Tiffany|Tiffany Studios|Frederick Wilson American, New York 1848–1933 New York|1902–32|American (born Ireland) Dublin 1858-1932 Los Angeles, California   Tiffany, Louis Comfort|Tiffany Studios |Wilson, Frederick 2361   1848 |1902 |1858 1933 |1932 |1932 1912 1912 1912 Watercolor, gouache, graphite, and powdered charcoal for pouncing 2573 34 9/16 x 20 1/4 in. (87.8 x 51.5 cm) Purchase, Walter Hoving and Julia T. Weld Gifts and Dodge Fund, 1967 Made in 1       United States 3             Drawings 9   Metropolitan Museum of Art, New York, NY 1
15473 67.654.317 0 0 16761 American Decorative Arts 1 Drawing 23 Four Seasons American 1         Artist|Maker|Artist 72   Louis Comfort Tiffany|Tiffany Glass and Decorating Company|Agnes F. Northrop American, New York 1848–1933 New York|American, 1892–1902|American, Flushing, New York 1857–1953 New York, New York   Tiffany, Louis Comfort|Tiffany Glass and Decorating Company|Northrop, Agnes F. 2390 American 1 1848 |1892 |1857 1933 |1902 |1953 ca. 1897–99 1897 1897 Watercolor, gouache, graphite, and red earth chalk pencil on on white wove paper formerly overmatted with original warm grey window matt 2651 Overall: 29 5/16 x 18 9/16 in. (74.5 x 47.2 cm) Other (Design): 24 7/8 x 18 7/16 in. (63.2 x 46.8 cm) Purchase, Walter Hoving and Julia T. Weld Gifts and Dodge Fund, 1967 Made in 1       United States 3             Drawings 9   Metropolitan Museum of Art, New York, NY 1
105980 17.190.1130 0 1 193817 European Sculpture and Decorative Arts 3 Snuffbox, painting 7005 Snuffbox with theatrical scenes of a rope dancer and a puppet show French, Paris 114         Artist|Maker|Artist 72 and|Box by|Miniature by Henri Joseph van Blarenberghe|Joseph Étienne Blerzy|Louis Nicolas van Blarenberghe French, Lille 1750–1826 Lille|French, active 1750–1806|French, Lille 1716–1794 Fontainebleau   Blarenberghe, Henri Joseph van|Blerzy, Joseph Étienne|Blarenberghe, Louis Nicolas van 9112 French|French|French 103 1750 |1750 |1716 1826 |1806 |1794 1778–79 1778 1779 Gold, enamel; vellum 21414 Overall (confirmed): 1 1/16 x 2 13/16 x 1 5/8 in. (2.7 x 7.1 x 4.1 cm); Miniatures: (sight measurements) top 1 3/16 x 2 3/8 (3 x 6 cm.); bottom 1 3/16 x 2 3/8 (3 x 6 cm.) Gift of J. Pierpont Morgan, 1917                       Metalwork-Gold and Platinum|Miniatures 317   Metropolitan Museum of Art, New York, NY 1
128719 11.148.1 0 1 219367 European Sculpture and Decorative Arts 3 Tapestry 1084 The Ascension from a set of The Passion German, Alsace, possibly Strasbourg 3698         Artist|Maker|Artist 72 Design based on a woodcut by||and Albrecht Dürer|Unidentified Weaver's Mark|Unidentified Weaver's Mark German, Nuremberg 1471–1528 Nuremberg , from the Small Passion|(ICM)|(AR) Dürer, Albrecht|Unidentified Weaver's Mark|Unidentified Weaver's Mark 12319 German 10 1471 1528 1592 1592 1592 Wool, silk, metal thread (20 warp threads per inch, 8 per cm.) 24607 39 1/4 x 29 3/4 in. (99.7 x 75.6 cm) Gift of J. Pierpont Morgan, 1911                       Textiles-Tapestries 186   Metropolitan Museum of Art, New York, NY 1

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "MetObjects" (
"Object Number" TEXT,
  "Is Highlight" INTEGER,
  "Is Public Domain" INTEGER,
  "Object ID" INTEGER,
  "Department" INTEGER,
  "Object Name" INTEGER,
  "Title" TEXT,
  "Culture" INTEGER,
  "Period" REAL,
  "Dynasty" INTEGER,
  "Reign" INTEGER,
  "Portfolio" INTEGER,
  "Artist Role" INTEGER,
  "Artist Prefix" REAL,
  "Artist Display Name" TEXT,
  "Artist Display Bio" TEXT,
  "Artist Suffix" REAL,
  "Artist Alpha Sort" INTEGER,
  "Artist Nationality" INTEGER,
  "Artist Begin Date" TEXT,
  "Artist End Date" TEXT,
  "Object Date" TEXT,
  "Object Begin Date" INTEGER,
  "Object End Date" INTEGER,
  "Medium" INTEGER,
  "Dimensions" TEXT,
  "Credit Line" TEXT,
  "Geography Type" INTEGER,
  "City" INTEGER,
  "State" INTEGER,
  "County" INTEGER,
  "Country" INTEGER,
  "Region" INTEGER,
  "Subregion" INTEGER,
  "Locale" INTEGER,
  "Locus" INTEGER,
  "Excavation" INTEGER,
  "River" INTEGER,
  "Classification" INTEGER,
  "Rights and Reproduction" REAL,
  "Link Resource" TEXT,
  "Metadata Date" TEXT,
  "Repository" INTEGER
,
FOREIGN KEY ("Department") REFERENCES [Department](id),
    FOREIGN KEY ("Object Name") REFERENCES [Object Name](id),
    FOREIGN KEY ("Culture") REFERENCES [Culture](id),
    FOREIGN KEY ("Dynasty") REFERENCES [Dynasty](id),
    FOREIGN KEY ("Reign") REFERENCES [Reign](id),
    FOREIGN KEY ("Portfolio") REFERENCES [Portfolio](id),
    FOREIGN KEY ("Artist Role") REFERENCES [Artist Role](id),
    FOREIGN KEY ("Artist Alpha Sort") REFERENCES [Artist Alpha Sort](id),
    FOREIGN KEY ("Artist Nationality") REFERENCES [Artist Nationality](id),
    FOREIGN KEY ("Medium") REFERENCES [Medium](id),
    FOREIGN KEY ("Geography Type") REFERENCES [Geography Type](id),
    FOREIGN KEY ("City") REFERENCES [City](id),
    FOREIGN KEY ("State") REFERENCES [State](id),
    FOREIGN KEY ("County") REFERENCES [County](id),
    FOREIGN KEY ("Country") REFERENCES [Country](id),
    FOREIGN KEY ("Region") REFERENCES [Region](id),
    FOREIGN KEY ("Subregion") REFERENCES [Subregion](id),
    FOREIGN KEY ("Locale") REFERENCES [Locale](id),
    FOREIGN KEY ("Locus") REFERENCES [Locus](id),
    FOREIGN KEY ("Excavation") REFERENCES [Excavation](id),
    FOREIGN KEY ("River") REFERENCES [River](id),
    FOREIGN KEY ("Classification") REFERENCES [Classification](id),
    FOREIGN KEY ("Repository") REFERENCES [Repository](id));
CREATE INDEX ["MetObjects_Department"] ON [MetObjects]("Department");
CREATE INDEX ["MetObjects_Object Name"] ON [MetObjects]("Object Name");
CREATE INDEX ["MetObjects_Culture"] ON [MetObjects]("Culture");
CREATE INDEX ["MetObjects_Dynasty"] ON [MetObjects]("Dynasty");
CREATE INDEX ["MetObjects_Reign"] ON [MetObjects]("Reign");
CREATE INDEX ["MetObjects_Portfolio"] ON [MetObjects]("Portfolio");
CREATE INDEX ["MetObjects_Artist Role"] ON [MetObjects]("Artist Role");
CREATE INDEX ["MetObjects_Artist Alpha Sort"] ON [MetObjects]("Artist Alpha Sort");
CREATE INDEX ["MetObjects_Artist Nationality"] ON [MetObjects]("Artist Nationality");
CREATE INDEX ["MetObjects_Medium"] ON [MetObjects]("Medium");
CREATE INDEX ["MetObjects_Geography Type"] ON [MetObjects]("Geography Type");
CREATE INDEX ["MetObjects_City"] ON [MetObjects]("City");
CREATE INDEX ["MetObjects_State"] ON [MetObjects]("State");
CREATE INDEX ["MetObjects_County"] ON [MetObjects]("County");
CREATE INDEX ["MetObjects_Country"] ON [MetObjects]("Country");
CREATE INDEX ["MetObjects_Region"] ON [MetObjects]("Region");
CREATE INDEX ["MetObjects_Subregion"] ON [MetObjects]("Subregion");
CREATE INDEX ["MetObjects_Locale"] ON [MetObjects]("Locale");
CREATE INDEX ["MetObjects_Locus"] ON [MetObjects]("Locus");
CREATE INDEX ["MetObjects_Excavation"] ON [MetObjects]("Excavation");
CREATE INDEX ["MetObjects_River"] ON [MetObjects]("River");
CREATE INDEX ["MetObjects_Classification"] ON [MetObjects]("Classification");
CREATE INDEX ["MetObjects_Repository"] ON [MetObjects]("Repository");
CREATE INDEX metobjects_IsHighlight ON MetObjects("Is Highlight");
CREATE INDEX metobjects_IsPublicDomain ON MetObjects("Is Public Domain");
CREATE INDEX metobjects_Department ON MetObjects("Department");
CREATE INDEX metobjects_Culture ON MetObjects("Culture");
CREATE INDEX metobjects_Period ON MetObjects("Period");
CREATE INDEX metobjects_Dynasty ON MetObjects("Dynasty");
CREATE INDEX metobjects_Medium ON MetObjects("Medium");
CREATE INDEX metobjects_City ON MetObjects("City");
CREATE INDEX metobjects_State ON MetObjects("State");
CREATE INDEX metobjects_County ON MetObjects("County");
CREATE INDEX metobjects_Country ON MetObjects("Country");
CREATE INDEX metobjects_Region ON MetObjects("Region");
CREATE INDEX metobjects_Subregion ON MetObjects("Subregion");
CREATE INDEX metobjects_Locale ON MetObjects("Locale");
CREATE INDEX metobjects_Locus ON MetObjects("Locus");
CREATE INDEX metobjects_Excavation ON MetObjects("Excavation");
CREATE INDEX metobjects_River ON MetObjects("River");
Powered by Datasette · Query took 119.075ms · Data license: CC0 · Data source: metmuseum/openaccess